IF EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'Cooprations'
          AND COLUMN_NAME = 'CodeEghtesadi'
)
    ALTER TABLE dbo.Cooprations ALTER COLUMN CodeEghtesadi VARCHAR(14);
ELSE
    ALTER TABLE dbo.Cooprations ADD CodeEghtesadi VARCHAR(14);



IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'Cooprations'
          AND COLUMN_NAME = 'SellerBranchCode'
)
    ALTER TABLE dbo.Cooprations ADD  SellerBranchCode VARCHAR(MAX);

